package org.example.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.example.pojo.*;

import java.util.List;

@Mapper
public interface VisualMapper {
    @Select("select * from test")
    List<Visual> list();
    @Select("select * from ads_rpt_trade_import_export_10y_d")
    List<IETenYearAll> listTenYearAll();
    @Select("select * from ads_rpt_trade_import_export_10y_d_2")
    List<IETenYearDis> listTenYearDis();
    @Select("select * from ads_rpt_trade_import_export_by_continent_5y_d")
    List<IEContinent> listContinent();
    @Select("select * from ads_rpt_trade_import_export_by_country_5y_d")
    List<IECountry> listCountry();
    @Select("select * from ads_rpt_trade_import_export_by_goods_y_d")
    List<IEByGoods> listGoods();
    @Select("select country_cn,year_23_ie_thd from ads_rpt_trade_import_export_by_country_5y_d order by year_23_ie_thd DESC ")
    List<IECountry> listCountries();
}
